package com.apes.fa.respository;

import com.apes.fa.model.FaEnableSituation;
import com.apes.framework.jpa.repository.CustomRepository;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

/**
 * @BelongsProject: apes-server
 * @BelongsPackage: com.apes.fa.repository
 * @ClassName: faEnableSituationRepository
 * @Author: PengZiFeng
 * @Description: 资产启停状态
 * @CreateTime: 2021-09-04 14:29
 * @Version: 1.0
 */
public interface FaEnableSituationRepository extends CustomRepository<FaEnableSituation,String> {

    @Query(value = "" +
            " SELECT " +
            " * " +
            " FROM " +
            " fa_enable_situation f" +
            " WHERE " +
            " f.fa_card_id = :id"
            ,nativeQuery = true)
    List<FaEnableSituation> findAllByFaCardId(String id);
}
